Dear all,
I am a complete excel newb and new mrexcel.com. I have no VBA experience at all. I have a long list of small tables of the form:
A B
1 Employee name1
2 Date1 Time1
3 Date2 Time2
4 Date3 Time3
There are five different dates possible for each table (for Mon-Fri) and all the times are also different. The dates and times are formatted as text. My question is how do I rearrange my data into one table that looks like this:
Date1 Date2 Date3 Date4 Date5
Employee1 Time1 Time2 Time3 Time4 Time5
Employee2 ... ... ... ... ...
I can't use VBA but could probably record a macro if I had to and I am using Excel 2016. Thanks so much for you help in advance I have been stuck on this for ages.
I am a complete excel newb and new mrexcel.com. I have no VBA experience at all. I have a long list of small tables of the form:
A B
1 Employee name1
2 Date1 Time1
3 Date2 Time2
4 Date3 Time3
There are five different dates possible for each table (for Mon-Fri) and all the times are also different. The dates and times are formatted as text. My question is how do I rearrange my data into one table that looks like this:
Date1 Date2 Date3 Date4 Date5
Employee1 Time1 Time2 Time3 Time4 Time5
Employee2 ... ... ... ... ...
I can't use VBA but could probably record a macro if I had to and I am using Excel 2016. Thanks so much for you help in advance I have been stuck on this for ages.