Hi all
I have been challenged and have had to concede defeat. I hope one of the gurus can assist with a solution.
(See attachment. Sheet named Original is how data looks originally and Sheet named Final shows what I am wanting to achieve - the scattered data left justified)
I have set up a worksheet so that column A contains yearly dates say A2 starts with 1/7/8 and increments by one day at a time down the column. Then columns B to D are initially blank. From column E on the columns are set up in multiples ie Col E contains Item, Column F contains Date (dates in these columns align with dates in Col A), column G contains Price. These three column headings are repeated many times across worksheet.
Data is scattered across the rows so that each row contains only one set of data relevant to the headings.
What I am wanting to do is to copy the scattered data into columns B to D (the blank ones) so that columns B to D is a left justified set of the scattered data set? Or is this too ambitious?
Your assistance is very much appreciated.
Regards
mgerada
I have been challenged and have had to concede defeat. I hope one of the gurus can assist with a solution.
(See attachment. Sheet named Original is how data looks originally and Sheet named Final shows what I am wanting to achieve - the scattered data left justified)
I have set up a worksheet so that column A contains yearly dates say A2 starts with 1/7/8 and increments by one day at a time down the column. Then columns B to D are initially blank. From column E on the columns are set up in multiples ie Col E contains Item, Column F contains Date (dates in these columns align with dates in Col A), column G contains Price. These three column headings are repeated many times across worksheet.
Data is scattered across the rows so that each row contains only one set of data relevant to the headings.
What I am wanting to do is to copy the scattered data into columns B to D (the blank ones) so that columns B to D is a left justified set of the scattered data set? Or is this too ambitious?
Your assistance is very much appreciated.
Regards
mgerada