sorry if i dont express clearly, My spreadsheet have hundreds of rows, each row in the spreadsheet is an individual record,when this file was exported, some fields in the records are not in one column. what I wanted to do is to align those fields which are not on the same column. e.g. balance...
Hi there,
I have an excel file which is exported from an application as illustrated below. How do it put cell A1,B2& C3 to the same column. Is there a macro or function which can use to automate this process. Ans the actual worksheet contain bulk of data which is almost impossible to do it...
Hui, thank you for your prompt reply,but how does the list '2,1,7,6,5,4,3' being workout ?
=(WEEKDAY(DATE(2010,9,1))) return the value of '4' and choose function pick up '6' as the value. I still in the dark. sorry about that.
Hi all,
I am not able to figure out the no series of "2,1,7,6,5,4,3" which shown in the choose function.
Can someone help ?
TIA.
When is Labor Day (US) in 2010?
Labor day (the US variant) is celebrated on first Monday of every September. It occurs on Sep 6th in 2010.
Using excel...