Hello
In my sample data, I want to reformat columns A B and C into the data in column F.
Is there a formulated way to do this rather than manually editing column F?
Hello
In my sample data, I want to reformat columns A B and C into the data in column F.
Is there a formulated way to do this rather than manually editing column F?
In F1.
=INDEX($A$1:$D$3,ROUNDUP(ROW()/4,0),IF(MOD(ROW(),4)>0,MOD(ROW(),4),4))&""
Copy down.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Amazing Thank you
You are welcome and thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks