Michaelbbeck
New Member
- Joined
- Dec 28, 2014
- Messages
- 25
H guys, great forum been checking in a while now, so thank you in advance. I am by no means an expert but can do a few intermediate things.
I have a question around grouped transpose - or thats what i have called it. I have a list of customers that have been collected without any thought of data.
The data is stacked in two columns as such. I can transpose but it doesn't work. Her is the format
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 100px"><col width="100"></colgroup><tbody>
</tbody>
You will see there are recurring headings. Id like the a column to be the header, then the B column underneath. I have about 1000 records is there an automated way to do this?
Once again thank you so much in advance.
Michael
I have a question around grouped transpose - or thats what i have called it. I have a list of customers that have been collected without any thought of data.
The data is stacked in two columns as such. I can transpose but it doesn't work. Her is the format
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
Name | aa |
Location: | bb |
Phone: | cc |
Fuel: | dd |
Water: | ee |
Power: | ff |
Name | uu |
Location: | vv |
Phone: | ww |
Fuel: | xx |
Water: | yy |
Power: | zz |
<colgroup><col style="width: 100px"><col width="100"></colgroup><tbody>
</tbody>
You will see there are recurring headings. Id like the a column to be the header, then the B column underneath. I have about 1000 records is there an automated way to do this?
Once again thank you so much in advance.
Michael