Share via

Transforming Columns into Rows

Anonymous
2022-09-13T01:36:31+00:00

Currently, all the information is in Row 1. Cell A1 has a Name. Cell B1 has an Address. Cell C1has a City. Cell D1 has a Name. Cell E1 has an Address. Cell F1 has a City. This 3 cell sequence repeats many times in Row 1.

I would like all the Names be in Column A. All the Addresses be in Column B. All the Cities in Column C. The end result would have information presented as follows:

Name Address City

A1 B1 C1

D1 E1 F1

G1 H1 I1

Etc

Etc

How can I accomplish this?

Thank you

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2022-09-13T03:41:55+00:00

Re: Convert data now in one row

Please see my response to an almost identical question in this forum... https://answers.microsoft.com/en-us/msoffice/forum/all/excel/fb248a24-c14f-48a9-9389-84bd6a3a94be?messageId=5ff41eb6-d71a-412c-b7d7-8e559c84d80f

It is titled "Excel" from July 17, 2022 by Tyty92

'---

Nothing Left to Lose

https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

(free excel programs)

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

3 additional answers

Sort by: Most helpful
  1. Anonymous
    2022-09-13T05:32:37+00:00

    Hi. Thank you for your question and reaching out. My name is John and I’d be more than happy to help you with your query.

    Assuming that you have a worksheet with information in sections that you want to turn to rework it in columns, utilize the Translate highlight. With it, you can rapidly change information from segments to columns, or the other way around. For more information, please see https://support.microsoft.com/en-us/office/3419f2e3-beab-4318-aae5-d0f862209744

    Best regards, John

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2022-09-13T03:16:23+00:00

    This is difficult for me to follow. Could you please explain it in a more simple, step by step manner.

    Thank you

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2022-09-13T03:01:59+00:00

    try this ...

    create temp table aa as select (rowid-1) /3 rows,(case 'c'||((rowid-1) % 3) when 'c0' then 'Name' when 'c1' then 'Addess' else 'City' end) cols,* from TransformingColumnsintoRows; select * from aa limit 9; cli_create_two_dim_no_order~aa~cols~content; select * from aa_two_dim;

    Was this answer helpful?

    0 comments No comments