Hi all,
I am trying to transpose data in column B and column V of my spreadsheet. I need the cells to basically transpose each row of a spreadsheet in those columns (I need column B to transpose to the cells in columns C,D,E,F,G, and I need column V to transpose to the cells in columns W,X,Y,Z,AA). I need to transpose these cells in each row depending on the text that is in column AG (home address column)...if it is a duplicate address I need the cells in columns C,D,E,F,G that have the same address in column AG to be transposed into the first row with that address. I need the same to happen with the data in column V. I have column headers, but no row headers. The first chart is what I have currently (the column letters are indicated), the second chart is what I would like the macro to do. If anyone can help me with this I would really appreciate it. Thank you so much!
Lindsey
<colgroup><col width="74" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;">
<col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;">
<col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;">
<col width="74" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;">
<col width="81" style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;">
<col width="83" style="width: 62pt; mso-width-source: userset; mso-width-alt: 3035;" span="2">
<col width="116" style="width: 87pt; mso-width-source: userset; mso-width-alt: 4242;">
<col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254;">
<col width="116" style="width: 87pt; mso-width-source: userset; mso-width-alt: 4242;">
<col width="119" style="width: 89pt; mso-width-source: userset; mso-width-alt: 4352;">
<col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254;" span="2">
<col width="116" style="width: 87pt; mso-width-source: userset; mso-width-alt: 4242;">
<col width="125" style="width: 94pt; mso-width-source: userset; mso-width-alt: 4571;">
<tbody>
</tbody>
I am trying to transpose data in column B and column V of my spreadsheet. I need the cells to basically transpose each row of a spreadsheet in those columns (I need column B to transpose to the cells in columns C,D,E,F,G, and I need column V to transpose to the cells in columns W,X,Y,Z,AA). I need to transpose these cells in each row depending on the text that is in column AG (home address column)...if it is a duplicate address I need the cells in columns C,D,E,F,G that have the same address in column AG to be transposed into the first row with that address. I need the same to happen with the data in column V. I have column headers, but no row headers. The first chart is what I have currently (the column letters are indicated), the second chart is what I would like the macro to do. If anyone can help me with this I would really appreciate it. Thank you so much!
Lindsey
Column B | Column C | Column D | Column E | Column F | Column G | Column H | Column U | Column V | Column W | Column X | Column Y | Column Z | Column AA | Column AG |
Account | Account 1 | Account 2 | Account 3 | Account 4 | Account 5 | Account 6 | Name | Name 1 | Name 2 | Name 3 | Name 4 | Name 5 | Name 6 | Address |
123456 | higgins | 1234 barcleigh st | ||||||||||||
78967 | higgins | 1235 barcleigh st | ||||||||||||
98765 | higgins | 1236 barcleigh st | ||||||||||||
334657 | higgins | 1237 barcleigh st | ||||||||||||
765467 | higgins | 1238 barcleigh st | ||||||||||||
333333 | higgins and smith | 1239 barcleigh st | ||||||||||||
65435 | clark | 6754 french ave | ||||||||||||
88888 | clark | 6755 french ave | ||||||||||||
76546 | goldstein | 2967 fort lee dr. | ||||||||||||
82263 | goldstein | 2968 fort lee dr. | ||||||||||||
91236 | stills | 1 drake st. | ||||||||||||
Column B | Column C | Column D | Column E | Column F | Column G | Column H | Column U | Column V | Column W | Column X | Column Y | Column Z | Column AA | Column AG |
Account | Account 1 | Account 2 | Account 3 | Account 4 | Account 5 | Account 6 | Name | Name 1 | Name 2 | Name 3 | Name 4 | Name 5 | Name 6 | Address |
123456 | 123456 | 78967 | 98765 | 334657 | 765467 | 333333 | higgins | higgins | higgins and smith | higgins and franks | higgins | higgins | higgins and smith | 1234 barcleigh st |
78967 | higgins and smith | 1235 barcleigh st | ||||||||||||
98765 | higgins and franks | 1236 barcleigh st | ||||||||||||
334657 | higgins | 1237 barcleigh st | ||||||||||||
765467 | higgins | 1238 barcleigh st | ||||||||||||
333333 | higgins and smith | 1239 barcleigh st | ||||||||||||
65435 | 65435 | 88888 | clark | clark | clark and bell | 6754 french ave | ||||||||
88888 | clark and bell | 6755 french ave | ||||||||||||
76546 | 76546 | 82263 | goldstein | goldstein | goldstein | 2967 fort lee dr. | ||||||||
82263 | goldstein | 2968 fort lee dr. | ||||||||||||
91236 | 91236 | stills | stills | 1 drake st. |