Using transpose or other way to make a table

**Mark00963** · 10-22-2019, 06:40 AM

Hello everyone,

The attached "ConvertSheet" is producing the "STOCK(TRANS) sheet automatically from sheet "Export", I'm trying to have the exact reverse operation like giving the table like in the "STOCK(TRANS)" and producing the sheet "Export".

can you help me?

thanks in advance.

**alansidman** · 10-22-2019, 03:25 PM

Using Power Query here is the Mcode for this action. If you are unfamiliar with PQ, click on the links in my signature.

Please Login or Register  to view this content.

The file is attached for your review.

Using transpose or other way to make a table

LinkBack

Thread Tools

Rate This Thread

Display

Using transpose or other way to make a table

Re: Using transpose or other way to make a table

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Using transpose or other way to make a table

To transpose or not to transpose? What decides? Table / Array?

TRANSPOSE OR NOT TO TRANSPOSE? How to change my table to a list format?

Transpose Help; I need to make every 4 rows into one row with 4 columns! Please!

transpose column to a range calculate and transpose to new table loop

[SOLVED] How to transpose two tables to make a one?

Coding to make a transpose values button

Bookmarks

Bookmarks

Posting Permissions