PDA

View Full Version : Excel Formula Help



DarrylW
08-11-2009, 07:58 AM
Hi,

Hope someone can help me with the attached.

As you can see there is 4 columns A – D with the date running down column A creating rows for the data. Is there a formula that will allow me put the 4 columns together for each day creating 1 row (see example)? The numbers are only in numerical order for this example

This would also be able to update if I was to add a new date.

Thank you fir any help!

Bob Phillips
08-11-2009, 08:58 AM
Try

=INDIRECT(ADDRESS(INT((COLUMN()-2)/(COUNTA($1:$1)-1))+2,MOD(COLUMN()-2,4)+2