Hi All,
Hope you are doing well, i have a problem where data is in a cell and i want to transpose it in separate columns based on the name, is it possible? please help thanks
Attached is the sheet for reference.
Input sheet - Column c data
Output sheet - need to transpose input sheet column c data in C-H column.
Try:
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Who knows ? Step by step:Originally Posted by Merrysa
Please Login or Register to view this content.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)
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, but i am facing difficulties to get the output on the below scenariosWho knows ? Step by step:
Please Login or Register to view this content.
1. sometimes what happens we can have few parts of the formula in another row (example highlighted in red (C3 cell))
2. fields can be increased (ex. Publish & Alt are added in C4 cell)
attached is the file for reference.
Thanks, but i am facing difficulties to get the output on the below scenariosTry:
Please Login or Register to view this content.
1. sometimes what happens we can have few parts of the formula in another row (example highlighted in red (C3 cell))
2. fields can be increased (ex. Publish & Alt are added in C4 cell)
attached is the file for reference.
We cannot offer any further help until you comply with the Administrator's request in Post #4.
Administrative Note:
Welcome to the forum.
Sorry, but your post does not comply with Rule #6 of our Forum RULES:
Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.
If you are unclear about the request or instruction, then send a private message to them asking for clarification.
All Participants:
Please do not post a reply in a thread where a Moderator or Administrator has requested an action that has not yet been complied with (e.g. title change, code tags requested, etc.). Thanks.
Apology i was not aware and i also posted it in another forum. please let me know how can i resolve it so someone can help on my question
posted link-https://chandoo.org/forum/threads/can-we-transpose-cell-data-in-different-column.48767/
Last edited by Merrysa; 08-31-2022 at 01:01 PM.
Apology i was not aware and i also posted it in another forum. please let me know how can i resolve it so someone can help on my questionAdministrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)
posted link- https://chandoo.org/forum/threads/ca...-column.48767/
Last edited by Merrysa; 08-31-2022 at 01:00 PM.
i have replied on the Administrator's request, let me know if anything else i have to do it so i can get answer on my question please
Please re-post your response to my macro suggestion.
Thanks, but i am facing difficulties to get the output on the below scenariosTry:
Please Login or Register to view this content.
1. sometimes what happens we can have few parts of the formula in another row (example highlighted in red (C3 cell))
2. fields can be increased (ex. Publish & Alt are added in C4 cell)
attached is the file for reference.
Please Login or Register to view this content.
Thanks, but it is struggling when data is increasing. have attached.Please Login or Register to view this content.
Please don't quote whole posts -- it's just clutter.*If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding
How are you 'struggling'???
Your latest attachment doesn't have my code, so that's why I guess.
When data is increasing with different string in the Input sheet macro gets stuck.
change "test" sub to
Please Login or Register to view this content.
Hi jindon,
Please find the attached file. thanks
Are you moving to next without confirming my last code is workign or not?
Hi Jindon, Its working perfectly for the sheet which i attached Thank you.
When i incorpoted the code with my macro then my macro is getting some references issue i know its with my macro nothing wrong with you code.
Now you are asking different question.
You must show us exact result that you want for one workbook.
Hi Jindon
Have attached the exact result of 2 data sheet. Thank you
I think you must open a new thread for this new question, clearly explaining how you want to separate.
I don't find any logic to separate the data.
Much thanks..
have opened a new thread. thanks for your help
https://www.excelforum.com/excel-pro...ml#post5723121
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks