Need help with moving data from col to col and rows

[Shinereed]

Need col a from this worksheet put in a second worksheet with 1 row between each
i need each item type in column b of this worksheet place in the second worksheet in a row next to the item name
i need each item id from col c of this worksheet placed in the second worksheet in a row right below the item type it corresponds to

[AliGW]

Administrative Note:

Is your forum profile up-to-date and showing ONLY the oldest Excel PRODUCT that you need this to work for?

Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

The three most recent Excel products are Excel 2019, Excel 2021, Excel 2024 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

Thanks.

[Estevaoba]

In cell A2 of Sheet2, try this array formula and copy down:

Please Login or Register  to view this content.

And this other array formula in cell B2 and copy across and down:

Please Login or Register  to view this content.

Array formulas must be confirmed by pressing Ctrl, Shift and Enter keys simultaneously. Then drag down and across.

When you do the array-entering right, you'll see curly brackets { } wrapping the formula in the formula bar.

I hope this helps.

Good luck!

[Czeslaw]

Power Query

Please Login or Register  to view this content.

[Shinereed]

I'll try this. Thank you. I'll let you know if it works.

[AliGW]

Plaese read and respond to post #2. Thanks.