how to change position of data.

[kghisla]

Hi, I attach a file to better describe what I need.
Briefly, it should be just a change of position of an series of data.
Thanks you all.
Carlo

[NBVC]

kghisla,

We are not here to play ping pong with you. You have now started at least 3threads on the subject... and the first 2, you have had people try to help you, Protonleah even offered a solution, which I am sure did not take him only 2 seconds to come up with for you (catered even to your workbook).

Please do not waste people's time in this way.

You need to better explain your problem by posting a workbook that shows some actual expected results in the positions they are to be placed... and tell us on what basis you think those should be the results.

We are here on our free time and do not appreciate when it is being wasted.

Thank you for your cooperation.

The ExcelForum Members.

[kghisla]

NBVC,

I don't understand what's not clear still. Did you see my file attached? Is it hard to get? I did explain everything in the attachment.

SUMIF does the sum of every invoice expiring every day (column B) and I need to visualize to which invoices is referring to.

Maybe since you usually solve very complicated problems, you expect my issue being complicated as well, but it's not. Look at the lowest chart and you'll see how I want it to be.

Please don't have any prejudice.

no ping pong, let's keep it clean.

I am very serious.

Thank you.

Carlo

[royUK]

There's no prejudice. You don't explain within your post but rely on the spreadsheet, not everyone can download.

Your posts make more work fo moderators, I've just closed your last one because you started this one.

Read the Forum Rules & follow them if you want free help

[NBVC]

kghisla,

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this

[kghisla]

Ok, I read the link in Re of cross posting. I understand it and since now on i will refer if I ask help to some other forum.
this is the link: http://www.ozgrid.com/forum/showthread.php?t=146081

no answer yet, i don't know how and if I can close it.

At the moment here this is the only open thread and in the attachment that i copy here I explain what i need.
Unfortunately the space I leave between letters and numbers is not respected and everything might end up too confusing and not readable. Please Open the file attached.

chart 1
columnA columnB column C
# invoice Amount Expiring date
1 $100.00 1-Sep-10
2 $300.00 2-Sep-10
3 $200.00 1-Sep-10
4 $150.00 3-Sep-10
5 $250.00 4-Sep-10
6 $350.00 3-Sep-10
7 $250.00 3-Sep-10

Formula i use in Column B: =SUMIF($C$2:$C$8,$A13,$B$2:$B$8)

chart 2
Accounts receivable
ColumnA B C D E F
September amount Invoice #
1-Sep-10 300
2-Sep-10 300
3-Sep-10 750
4-Sep-10 250
5-Sep-10 0

I would like the invoice # chart1 column A in column C-F
Below it's how I would like it.

chart3
ColumnA B C D E F
Accounts receivable
September amount Invoice #
1-Sep-10 300 1 3
2-Sep-10 300 2
3-Sep-10 750 4 6 7
4-Sep-10 250 5
5-Sep-10 0


Please don't tell me that I don't explain what I want.
I'd rather been told that you don't want to help me this time.

I respect any decision.

[NBVC]

In C13, try:

=IFERROR(INDEX($A$2:$A$8,SMALL(IF($C$2:$C$8=$A13,ROW($A$2:$A$8)-ROW($A$2)+1),COLUMNS($A$1:A$1))),"")

confirmed with CTRL+SHIFT+ENTER and copy across the matrix

[kghisla]

I did it but i don't see anything, nothing happens.
It would be good if you attached a file with your suggestion.

FYI, in the other forum, today I got a possible solution using a Pivot Table.
I attach the file in the sheet 2, and this is the link:
http://www.ozgrid.com/forum/showthre...goto=newpost**

It seems it works just fine, the only problem is that I dont' know how to use it.
Any suggestion for an easy example I can study to get it?

thank you again.

Carlo

[NBVC]

With my formula if you noticed that I bolded the statement:

Confirm with CTRL+SHIFT+ENTER

So, after you enter the formula you have to hold the CTRL and SHIFT keys down and hit ENTER.. then copy down and across.


Google Pivot Tables tutorials to find pivot table tutorials.

[kghisla]

I noticed the bold instruction, and I did it but not correctly. I thought maybe the reason was I am using a Macbook, but today I actually entered the formula myself and after CNTRL+SHIFT +Return, the curly brackets appeared.

NBVC, thank you very much for your help, I'm very excited.

Now I will modify it for the original file that was more complicated than the sample.
Hopefully I will make it.

Best to you, and thank you again.

Carlo