• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Fancy report placed related cells in different rows and columns

C

chicagorob

New Member
Hi, I'm new to the Chandoo forums, so please be gentle....

I have a problem that may turn out to have a simple answer, I just don't know enough to recognize it. We have a report that lays out data fields for a single document all over the page. The client's name may be in A1, their phone number in C1, but their contact name is in B4. There's extra spacing, along with hidden rows, columns and randomly merged fields.

When it was created as a visual report, it looks really good, but as a spreadsheet to manipulate, etc. it's impossible, at least for me.

Does anyone have any magic tips, tricks or processes so I can pull data for several thousand entries from this tricked out report to a straight Excel spreadsheet, with all of data for each entry in the same row?

Thank You!
 

Attachments

  • Chandoo Example.xlsx
    12.5 KB · Views: 5
Hi ,

Is it possible you can upload a workbook which has more than one record ?

If your workbook had adequate data , it would make it easier to understand how one record is to be distinguished from the next.

Narayan
 
NaraYank991,

Thanks, I didn't think of the layout of multiple entries. My first example was a crude mock-up of what my report looks like.

I work in healthcare, so our data has to remain secure. For this example I took the first few entries of the original file and changed all names and identifying data.

You'll find that this example is a lot more complex. some fields, like MRN are not in every section.

thanks, chicagorob
 
chicagorob said:
NaraYank991,

Thanks, I didn't think of the layout of multiple entries. My first example was a crude mock-up of what my report looks like.

I work in healthcare, so our data has to remain secure. For this example I took the first few entries of the original file and changed all names and identifying data.

You'll find that this example is a lot more complex. some fields, like MRN are not in every section.

thanks, chicagorob
Click to expand...

Did you upload a new file? - make sure it's completely sanitized - we don't want you & your organisation getting HIPPA-d
 
You must log in or register to reply here.
Back
Top