Hi,
i would like to write code that will copy rows and paste them for one column (in one list).
For example: i'd like to copy range A1:C3 and paste it for one column.
Could you help me?
Hi,
i would like to write code that will copy rows and paste them for one column (in one list).
For example: i'd like to copy range A1:C3 and paste it for one column.
Could you help me?
A quick two steps in Power Query. No code required. Highlight your range and Unpivot Rows. Delete the first column. See the attached. Here is the Mcode generated by these steps.
Review PQPlease Login or Register to view this content.
In the attached file
Click on any cell in the new table
On the Data Tab, click on Queries & Connections
In the right window, double click to open Query
Review PQ steps
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thanks it's work very well.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks