Hello please help me to convert a sheet1 information to sheet 2 template information.
2.jpg
Hello please help me to convert a sheet1 information to sheet 2 template information.
2.jpg
Last edited by alexxl; 11-20-2017 at 04:41 PM. Reason: Error
Attach a sample workbook (not image).
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.
Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
I did! Tx for your help and guide!
In D3
=SUMPRODUCT(('Data to be transformed'!$E$2:$E$18)*('Data to be transformed'!$A$2:$A$18=D$1)*('Data to be transformed'!$C$2:$C$18=$A$3)*('Data to be transformed'!$B$2:$B$18>=TIMEVALUE(LEFT($B3,5)))*('Data to be transformed'!$B$2:$B$18<=TIMEVALUE(RIGHT($B3,5))))
Copy across and down to row 6
in D7
=SUMPRODUCT(('Data to be transformed'!$E$2:$E$18)*('Data to be transformed'!$A$2:$A$18=D$1)*('Data to be transformed'!$C$2:$C$18=$A$7)*('Data to be transformed'!$B$2:$B$18>=TIMEVALUE(LEFT($B3,5)))*('Data to be transformed'!$B$2:$B$18<=TIMEVALUE(RIGHT($B3,5))))
copy across and down
Repeat for each station, changing highlighted range
3.jpg
It points me an error.
Works on your posted file: so what is different??
Save file as XLSX.
I will call you my hero and may be the lord keep you in peace
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Well i guess i use , instead of ; I can tell you that i was investing tremendous work in a much more biger file with 1000 products on a huge scale of station. This was a minimalist example. I still have to do some pivots in order to achiev data to be transformed. But with a macro and this i ll save 2 3 hours of work. Can i give you a beer? )
Last edited by alexxl; 11-20-2017 at 05:26 PM.
Done done done
Last edited by alexxl; 11-20-2017 at 05:56 PM.
I solve it it was about some errors.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks