Transpose data based on value changing in 1st column

jiddings

Board Regular
Joined
Nov 22, 2008
Messages
135
I have data that exports from a database with the following format and I need to format the data to the desired transposed data format.
How do I accomplish this? The data is only a snippet of the data.

Date Time Value
4/19/2013 23:13:00 51
4/20/2013 0:46:00 56
4/20/2013 7:05:00 126
4/21/2013 9:09:00 77
4/21/2013 12:09:00 75
4/22/2013 14:12:00 105

Desired result after transpose
Date Time1 Value1 Time2 Value2 Time3 Value3
4/19/2013 23:13:00 51
4/20/2013 0:46:00 56 7:05:00 126
4/21/2013 9:09:00 77 12:09:00 75
4/22/2013 14:12:00 105
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
select the current range to make this ease on numbers lets say its a1:b10
that is 2 columns and 10 rows
go to the place in the spreadsheet where you wnat the data and select 10 columns and 2 rows leaving the active cell in the first cell type =transpose(A1:b10) then conform with Ctrl+shift+enter
 
Upvote 0
What suggested is not dong what I need to do. I need to transpose the data each time the date changes for the respective time and its value so that it has a format of "Date Time1 Value1 Time2 Value2 Time3 Value3" for example for each row. I thought this would / may need a VBA macro to do this.
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,238
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top