vba - How to split a row into columns for every three columns in excel? -

-

In Excel, how do I split a line into a set of columns? In A1: G1, the data should be in the first line, then A1: C1 will be similar to the first row, D1: G1 should be from the end of the first line. This should continue till the data in the first row is limited to G1. .

I have data like 

  ABCDE ... AE Air Force AG 1 AB 2013/01/12 2013/02/23 233 2013/02/24 2013 / 03/11 500 2 CD 2013/01/12 2013/02/23 233 2013/02/24 2013/03/11 343. I need this:  
   ABCDE 1AB 2013/01/12 2013/02/23 233. 1 AB 2013/02/24 2013/03/11 500 2 CD 2013/01/12 2013/02/23 233. 2 cd 2013/02/24 2013/03/11 343.   
 How can this be done in Excel, I tried to write a VB script, but it did not go anywhere. Nobody can help me with this.   
 
 
 OK, so it seems that you have two cells with a static id and the name is three There is a series of cells that show a pattern of  date ,  date ,  number . You want to take everything on the right side of the first two cells, repeating the two rows. It should do.   
 sub-split_and_stack () as long as slow, long time, as long as the LC, LR, as long as dim ws1 worksheet, set ws2 worksheet As ws1 = ActiveSheet Sheet. : = Sheets (Sheets.Count) Set ws2 = Sheets (Sheets.Count) ws2.Cells (1, 1) .Resize (1, 5) = array ("id", "name", "start", "end "," Number ") ws1 lr =. With (rows.count, 1). End (XLEEP) .ro lc = .sec (1, column.account). End (XLTOLET) For column R = 1 LR for C = 3 for LC phase 3 ws2.Cells (rows.Count, 1). End (XLEP). Offset (1, 0). Resize (1, 2) = _ (R, 1). Repeat (1, 2). Value ws2.Cells (rows. Count, 1). End (XLEP). Offset (0, 2). Resize (1, 3) = _ (R.C.). Resize (1, 3). Price Next C Next With R & End And End Sub   
 The following image can not show the correct date but you should get general knowledge. It is always a good idea to not provide such a vague date that is written in the form of  mm / dd / yy  or  dd / mm / yy  while supplying sample data May be.  
 One Enter image details here

Comments

Post a Comment

Popular posts from this blog

php - PDO bindParam() fatal error -

-
I am trying to learn PDO, now I have written this small code, but it gives me a serious error: Fatal error: Call a member function at a non-object dot () ... $ con = new mysqli ("127.0.0.1", "root", "", "csvdangercheck"); $ Query = $ con- & gt; ("Id,` var1`, `var2`) values ​​(" id,: var1,: var2) ";); $ query- & gt; bypass pattern (': id', $ id); $ query- & gt; BindParam (': var1', $ VAL1); $ Query- & gt; bindParam (': var2', $ val2); $ Query-> Executed (); I Trying to use print_r ($ con-> errorInfo ()) but Fatal error: Undefined method mysqli :: errorInfo ( ) ... can someone tell me what am I missing? Flaffeh said, you have PDO Missing Mysqy, try it: $ con = new PDO ('mysql: host = 127.0.0.1; dbname = csvdangercheck', 'root', '');
Read more

php - How can I cram 6+31 numeric characters into 22 alphanumeric characters? -

-
I have a 6 digit number and a 31-digit number (such as "234536" and "201103231043330478311223582826") that I The API needs to be crawled in the same 22-character alphanumeric field that uses PHP. I tried to convert each one to 32 (using custom code could not handle the base_convert () large number) and to connect with a single-character delimiter, but It only gives me 26 characters This is a restore API, so the letters should be URI-protected. I would like to do a database table cross with two references without reference to another reference value, if possible, any suggestions? Instead use a radix of 62. This will give you 22 characters for the top, 3.35 for the pre and 17.3 for the next. & gt; & Gt; & Gt; Math.log (10 ** 6) /math.log (62) 3.3474826039165504 & gt; & Gt; & Gt; Math.log (10 ** 31) /math.log (62) 17.295326786902177
Read more

logging - How can I log both the Request.InputStream and Response.OutputStream traffic in my ASP.NET MVC3 Application for specific Actions? -

-
For a specific set of tasks, I need to log in to the incoming request inputstream as well as outgoing response. is. I am using an ActionFilterAttribute for this and overriding the OnActionExecuted and OnResultExecuted methods. So I'm starting with this idea ... Public category ActionLoggerAttribute: ActionFilterArrbit {Public Override Zero On-Offed Execution (ActionActioned Contact Filter Filter) {base.OnActionAxecuted (FilterContext); HttpRequestBase request = filterContext.HttpContext.Request; // TODO: Log the request. InputStream} Public Override Zero OnResultExecuted (ResultExecutedContext FilterContext) {base.OnResultExecuted (filterContext); HTTPRPSPointBase Response = FilterContacts Hpptex response; // TODO: Log on Response.OutputStream}} Ideally I'll hook it up with enterprise library logging because I'm already using it for error logging. Am I reaching the input and output stream at the right time? Can I easily use the Enterprise Library to log i...
Read more