Data in Report not appearing correctly

[arunku]

Hi ,

I have a report which is having 11k data . The problem is the data coming under the cells has got interchanged.

Example:

For few cells the data is coming in the below order

pointsBalance:0***************"firstName":"KAMARDEEP"*****"lastName":"DHILLON"
pointsBalance:116720 firstName:"GREGORY" lastName:"MACMILLAN"

But in few other cells data is coming in the below order

lastName:"GLAVINE"************"pointsBalance":50287*******"firstName":"ANDREW"
lastName:"GOODFELLOW" pointsBalance:86199 firstName:"AMBER"


Is it possible to make the data in an uniform way.i tried filter but not yielding results.Could you please help.

[Kaper]

Will you please attach a SMALL sample Excel workbook(s) (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!

To attach an Excel file you have to do the following: Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.

[arunku]

Attached the Report, removed Individual names

The desired format is

Firstname LastName PointsBalance

[Kaper]

Use in C1:

Please Login or Register  to view this content.

or if you need doublequotes:

Please Login or Register  to view this content.

very similar formula (but with lastName) in D1

In E1:

Please Login or Register  to view this content.

[arunku]

This method worked.Thank You

[Kaper]

I'm glad to hear about it, and thanks for marking thread Solved and for reputation point