Hi,
I'm working with a spreadsheet that is exported with poor formatting and I'm looking for a way to transpose every other cell in a column up on unit and right one unit (i.e. going from G3 to H2 then skip G4 and do it again on G5). I've looked all over other forums for a VBA that would work on this but the solutions that I've ended up with haven't done it correctly.
I'm hoping for it to go from this:
sheet1.png
To this:
sheet2.png
Thanks for the help!
Hi and welcome to the forum.
Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context. Not many of us are willing to recreate your workbook for testing purposes when you have one available.
Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Richard,
Thank you for letting me know.
Here is an excel file with a sheet that depicts how the data is in its current state (Initial Data) and another sheet that shows what I'm trying to achieve (Desired Output). The action that I'm looking to do is to move the cell contents from G3 to H4, G5 to H5, G7 to H7 - and so forth.
Thanks!
Hi,
Assuming you have copied The initial Data to the Desired Output then on the Desired Output
I2
Formula:
Please Login or Register to view this content.
J2
Formula:Please Login or Register to view this content.
both copied down.
Fantastic! That worked - thank you so much!
My pleasure.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks