LinkBack URL
About LinkBacks
I've got several pairs of columns, that I want to append into just two pairs.
Please see attachment example of my current data and how I would want it to look.
I've got several pairs of columns, that I want to append into just two pairs.
Please see attachment example of my current data and how I would want it to look.
No attachment ... yet.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Apologies please see attachment
How aboutFormula:
Please Login or Register to view this content.
Here's a PowerQuery solution.
M Code:
There are links in my signature line about PQ, but shout if you need guidance.
Please Login or Register to view this content.
Thanks for this, I am trying to follow your steps from the code backwards but not understanding.
Could you outline the steps taken?
Which solution are you referencing - mine or Fluff's?
Yours please.
OK - give me half an hour (just busy with something else, but will write instructions after that).
You will need to follow these steps using the workbook you shared in Post #3, NOT the one I shared with you after that.
First you need to create the named ranges that PQ will use (see image 01 below).
Next, go to Data | Get Data | From Other Sources | Blank Query.
In the PQ window formula (fx) bar, type this: = Excel.CurrentWorkbook()
Use the drop-down arrow on the Name column | Text Filters | Begins with ... and type Range into the first filter box in the dialog > OK.
Use the double-headed arrow button on the Content column and DESELECT the tick box underneath the selection list > OK.
In the Query Properties panel on the right, change the query name to Results.
Click to select the Name column | Right click | Remove.
Top right Close & Load button - click to reveal the drop-down, and choose Close & Load To ... (I selected Exixting Worksheet and nominated a starting cell).
Thant's it.
Formulas
Column1Formula:Please Login or Register to view this content.
Column2Formula:Please Login or Register to view this content.
drop down
@AliGW
Thanks a lot for this really helpful!
Last edited by AliGW; 02-14-2022 at 06:57 AM. Reason: PLEASE don't quote unnecessarily!
You're welcome.
If you have not already done so, 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 all those who offered help.
Here's an alternative, which doesn't need you to create the named ranges, and will work with any width of source table:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Formulas error
Column1Formula:Please Login or Register to view this content.
Column2Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks