I have a file with a 2 fields in columns (name, date) and a "notes" field in rows under each name. I would like to move the "notes" field to a column. How can I accomplish this? I've attached a screen print of what I'm trying to do.
2018-01-04_10-19-50.jpg
Hi. One example is not enough to see the underlying pattern. please repost a sample file with about 5-10 representative datasets.
We can't see how many rows there are before the next dataset begins, if the number of rows per dataset is always 2 lines, if the number of blank rows is always the same, etc, etc.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
The data contains confidential information so I can't post the actual data. But the data is in a consistent pattern of 2 rows per record, with no blank rows between records. I've manipulated and formatted the data to that point. It's just moving row2 of each record to column c that I'm not sure how to accomplish.
we do not need any "proprietary data" ...
... anything ... is what we need ... jagged.gif
This is for this arrangement/layout - Next ... the result:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks