Here is my issue.
I have a bunch of information in the range A7:D2000. This information includes a business name in column A and an account number in column D. I am looking to transfer this information while transposing it to another sheet. For each company in column A, they could have several different accounts in column D. As in, Company 1 would be listed as the company in column A for rows 7-12 but the account number in column D would be different for all of these lines.
My desired end goal is to transpose this information to a form where each individual company name will be listed in the range A2:CZ2 (and be able to expand as we add more companies) with the individual account numbers for each below them.
Here is a rough approx of what I’m thinking.
First Sheet
Company Name x x Account Number
1 ABC
1 DEF
2 90
2 95
2 100
2 105
2 110
Second Sheet
Company name 1 2
ABC 90
DEF 95
100
105
110
Or if there is a way to Index/Match it for other calculations where the information is on the first sheet, that would work too. Thank you very much for any help, and if this is confusing, I'll try my best to clarify it. I am doing this manually now and just want to find some way to not have to do so.
I have a bunch of information in the range A7:D2000. This information includes a business name in column A and an account number in column D. I am looking to transfer this information while transposing it to another sheet. For each company in column A, they could have several different accounts in column D. As in, Company 1 would be listed as the company in column A for rows 7-12 but the account number in column D would be different for all of these lines.
My desired end goal is to transpose this information to a form where each individual company name will be listed in the range A2:CZ2 (and be able to expand as we add more companies) with the individual account numbers for each below them.
Here is a rough approx of what I’m thinking.
First Sheet
Company Name x x Account Number
1 ABC
1 DEF
2 90
2 95
2 100
2 105
2 110
Second Sheet
Company name 1 2
ABC 90
DEF 95
100
105
110
Or if there is a way to Index/Match it for other calculations where the information is on the first sheet, that would work too. Thank you very much for any help, and if this is confusing, I'll try my best to clarify it. I am doing this manually now and just want to find some way to not have to do so.
