HELP WITH EXCEL

Question

Struggling to do a simple transition in Excel if anyone can give some advice:&nbsp;I have 3 items I need to run up &amp; down instead of across... is there any easy way ??? So I need the Name and two of the xx Boxes to run from top to bottom... I did the first two but I did them cell by cell.... is there a formula that will take the entire thing and create what I need?Adriana Zaragoza Lopez&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Alejandro J Escobedo&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Alyssa Christina&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Amber H McCord&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Ana C DePaz&nbsp;&nbsp;&nbsp;xx&nbsp;&nbsp;&nbsp;xx&nbsp;xx&nbsp;&nbsp;&nbsp;xx&nbsp;xx&nbsp;&nbsp;&nbsp;xx&nbsp;xx&nbsp;&nbsp;&nbsp;xx&nbsp;xx&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Adriana Zaragoza Lopezxxxx&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Alejandro J Escobedoxxxx&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

snowman55 · Answer

Usually to handle something like this, you would consider the TRANSPOSE function. But as you do not want all those cells in the output area, see one of the possible techniques in this workbook: 2026-06-25 CD copying data in rows to columns.xlsx

nikolinode · Answer

Formula suggestion if Office 365 is being used…

=LET(

data, A1:Z2,

row1, INDEX(data, 1, SEQUENCE(, COLUMNS(data))),

row2, INDEX(data, 2, SEQUENCE(, COLUMNS(data))),

pos, FILTER(SEQUENCE(, COLUMNS(data)), row1<>""),

names, INDEX(row1, pos),

xx1, INDEX(row2, pos),

xx2, IFERROR(INDEX(row2, pos+4), ""),

out, HSTACK(TRANSPOSE(names), TRANSPOSE(xx1), TRANSPOSE(xx2)),

FILTER(out, INDEX(out,,1)<>""))

If you want a truly bulletproof version...

The only 100% flexible solution (no offsets at all) is:

Power Query “Unpivot + Group by Name detection”

That approach:

doesn’t care about spacing
doesn’t care about columns
rebuilds structure logically

My answers are voluntary and without guarantee!

Hope this will help you.

sergeibaklan · Answer

As a commentINDEX(data, 1, 0)or evenINDEX(data, 1, )works exactly the same way asINDEX(data, 1, SEQUENCE(, COLUMNS(data)))Plus names with numbers (row1, row2, etc) are not accepted within LET. It could be rowA, rowB, etc.

Forum Discussion

HELP WITH EXCEL

3 Replies