Transpose and repeat column header on rows

Question

I've got a list with a huge amount of columns. I want to repeat the column header on each row and put all the columns into just two.

I start with this:

The result should be:

Does anyone have any idea if how I can do this? Thanks

Which version of Excel are you using?? – Vasim Sep 04 '15 at 11:45 — Vasim, Sep 04 '15 at 11:45
Do you have power query? what you need is unpivot – Balinti Sep 04 '15 at 12:10 — Balinti, Sep 04 '15 at 12:10
No I dont, Might have to take a look at that – gudmualb Sep 04 '15 at 12:30 — gudmualb, Sep 04 '15 at 12:30

score 0 · Answer 1 · edited May 23 '17 at 12:22

0

Assuming Person1 is in A1, insert and label a new ColumnA then unpivot (eg as described in detail under Convert matrix to 3-column table ('reverse pivot', 'unpivot', 'flatten', 'normalize') and filter to delete rows blank under Value.

edited May 23 '17 at 12:22

Community

answered Sep 04 '15 at 15:27

pnuts

score -1 · Answer 2 · answered Sep 08 '15 at 10:36

-1

answered Sep 08 '15 at 10:36

gudmualb

2 Answers2