Recent content by Brianfree

Thankyou Mikrom, will have a play but looks perfect thankyou!!

Hello, i have excel document containing 2 columns.. AAA, 123 AAA, 234 BBB, 345 CCC, 456 DDD, 567 DDD, 678 DDD, 789 ETC.. Need to convert the rows to columns but preserve the first row.. So would need it to look like.. AAA, 123, 234 BBB, 345 CCC, 456 DDD, 567, 678, 789 ETC.. I can find...

sorry, I put on the wrong code that I was working on. You can see what I am trying to do.

Hello, it was to use nested statements but having problems trying to figure it out. this is what I have so far.. <?php foreach(range('A','C') as $location) { foreach(range('L','M') as $position) { for ($y = 1; $y <= 32; $y++) { echo $location ."-". $position ."-".$y; echo "<br>"...

hello, please can anyone assist with my request for college. I am trying to write a program on php which does the following and then I can use on a html drop down For the Alphabet letters.. A,B,C,D - I want to create a loop that creates the following A-L-01 A-R-01 A-R-01 A-L-02 A-M-02 A-R-02...

Hi Sorry, i cant find a way to format this, is this what you mean? NAME, VALUE1, VALUE2, VALUE3, VALUE4, VALUE5 JOHN, 10, 12, 14, NULL, NULL PAUL, 8, 10, NULL, NULL, NULL SARAH, 1, 2, 3, 4, 5 Many thanks BF

Sorry, i meant.. NAME VALUE1 VALUE2 VALUE3 VALUE4 VALUE5 JOHN 10 12 14 NULL NULL PAUL 8 10 NULL NULL NULL SARAH 1 2 3 4 5 The Name columne could be hundreds od rows and the value column could be up to 20 i hope this helps...

Sorry, Andrzejek reply. Many thanks

perfect thankyou

HI, how can i create simple sql pivot to do this.. [current output] NAME, VALUE JOHN, 10 JOHN, 12 JOHN, 15 PAUL, 8 PAUL, 10 SARAH, 1 SARAH, 2 SARAH, 3 SARAH, 4 SARAH, 5 etc... [new output] NAME, VALUE1, VALUE2 JOHN, 10, 12, 14 PAUL, 8, 10 SARAH, 1, 2, 3, 4, 5 etc... Many thanks Brian

Hi, thankyou chris - ive been trying this but im still getting rows back where i dont want them.. Have you an exmaple for me to look at? many thanks bf

hello, i have data that is returned on mssql but i need to remove the rows where there are multiple positions this is what i currently get... oem, position ABC123, LHF ABC124, RHF ABC124, LHF ABC125, LHR ABC126, RHF ABC127, LHF ABC128, LHF ABC128, RHF ABC128, RHR ABC129, LHR i need the data to...

Hello, i am looking to create a vba file that can be run from desktop to do the following.. Please can someone assist? 1) copy a text file locally that is on a server. Will need to pass server address and location and username/password 2) display contents of text file with "ok" button...

Hi, thanks for your response. I have multiple documents with 10,000s rows of data... Ive not yet started anything yet as i dont know how to create a vba program sorry Many thanks Brian

Hi, i have an excel spreadsheet with data that looks like below... REF, VALUE, QTY 0414701006, 0414701053/084, 2 0414720088, 0414720018/029/038, 80 i need to be able to seperate the values to new rows but preserve the Ref and Qty. In addition to this, if there are /xxx numbers i need to...