Hi. I have this sheet that I want to transpose into an easier to read format. I don't know how to write a VBA code for each. I can write a CONCATENATE formula but prefer a simple VBA code that I can adjust later if required, as I'm a noob.
Thank you for your help.
TO this table below.
Each Cell below the headers will have:
Date
PR#
PR NAME
Thank you for your help.
A | B | C | D | E | F | G | H | I |
HEADER1 | pr# | PR NAME | PM | DEADLINE | HEADER6 | HEADER7 | HEADER8 | HEADER9 |
123 | Sample1 | NAME1 | 25-Dec-20 | |||||
234 | Sample2 | NAME1 | 26-Dec-20 | |||||
345 | Sample3 | NAME1 | 27-Dec-20 | |||||
456 | Sample4 | NAME2 | 28-Dec-20 | |||||
457 | Sample5 | NAME3 | 29-Dec-20 | |||||
458 | Sample6 | NAME4 | 30-Dec-20 | |||||
459 | Sample7 | NAME5 | 31-Dec-20 | |||||
460 | Sample8 | NAME3 | 1-Jan-21 | |||||
461 | Sample9 | NAME4 | 2-Jan-21 | |||||
462 | Sample10 | NAME5 | 3-Jan-21 | |||||
SHEET 2 | ||||||||
TO this table below.
Each Cell below the headers will have:
Date
PR#
PR NAME
A | B | C | D | E | F | G | H |
NAME1 | NAME2 | NAME3 | NAME4 | NAME5 | NAME6 | NAME7 | NAME8 |
CONCATENATE | |||||||
12/25/2020 PR#123 PR NAME | 12/28/2020 PR#456 PR NAME | ||||||
SHEET1 | |||||||