How to do an arrayformula that transposes a list while multipling the entries? [closed]

Question

I have a list of rows, and I like to transpose them into a list of columns.

But the trick is how do I repeat each of the new columns 4 times (1 row will become 4 columns)?
Alternatively, how do I add a suffix to each new column (1 row will become 4 columns but each column will have a different suffix)?

To clarify, here are example input and output.

Input:

	A
1	a
2	b
3	c

Needed output in C1:

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	a		a	a	a	a	b	b	b	b	c	c	c	c
2	b
3	c

Alternatively:

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	a		a suffix1	a suffix2	a suffix3	a suffix1	b suffix1	b suffix2	b suffix3	b suffix4	c suffix1	c suffix2	c suffix3	c suffix4
2	b
3	c

Answer 1

I hope it's okay to answer, I just thought it will help others: C1 should be =arrayformula(SPLIT(JOIN(",",REPT(filter(unique(A:A), unique(A:A)<>"")&",",4)),",")).

Basically it joins the rows using a comma, then splits them horizontally (since that's how Split works, thus sparing us from using Transpose).

• Filter with <>"" is needed to avoid blanks rows (otherwise you need to limit manually, for example A1:A52 when A53 and beyond aren't used).
• Unique is needed because it otherwise fails when there are duplicates in column A.

Alternatively, there's a way to get manual values instead of repetition by making C1 into =ARRAYFORMULA(TRANSPOSE(FLATTEN(CONCAT(filter(unique(A:A), unique(A:A)<>""),{concatenate(" ", "suffix1"), concatenate(" ", "suffix2"), concatenate(" ", "suffix3"), concatenate(" ", "suffix4")}))))

Then C1's output will be a suffix 1, d1's will be a suffix 2...and g1 will likewise be b suffix1 and so on.