Adding blank cells to a list

[Nimal]

Hi,

This should be pretty straight forward, just can't for the life of me work out how to do it.
I've got a list of data in column A that I want to move into a new list but split up so every other cell is blank.
Eg. Cell A2 will be replicated into B2, but cell A3 will replicate in B4 leaving B3 blank.
The data changes on a regular basis so basically want formula that can do this.
Any help could be appreciated

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Nimal]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’

 

[Nimal]

Sorry, hadn't thought to update.
Should be updated now.
Is 365 and Windows

 

[Fluff]

Thanks for that.
How about

++Fluff.xlsm
	A	B
1
2	A	A
3	B
4	C	B
5	D
6	E	C
7	F
8	G	D
9	H
10	I	E
11	J
12	K	F
13	L
14	M	G
15
16		H
17
18		I
19
20		J
21
22		K
23
24		L
25
26		M
27
Data

Cell Formulas
Range	Formula
B2:B26	B2	=LET(s,SEQUENCE(ROWS(A2:A14)*2-1),IF(ISODD(s),INDEX(A2:A14,INT(s/2)+1),""))
Dynamic array formulas.

 

[Nimal]

Works a charm.
Thank you very much

 

[Fluff]

You're welcome & thanks for the feedback.