Hello,
I have this table, I would like that each name will get line for each question. See example in the sheet.
Any idea how to do that easily?
Thanks
M
Hello,
I have this table, I would like that each name will get line for each question. See example in the sheet.
Any idea how to do that easily?
Thanks
M
I think you are going to need to walk us through what you are doing here.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I wrote a UDF just for this sort of task
RETURNELEMENTS
If your source data is in A2 for example
Then =returnelements(A2,char(10), x ) where x is the row to extract.
You have posted in an Access Forum. Is this an Access or Excel issue.
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
Do you need changes in Excel or Access document?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks