Question: Assuming my column is A:

I have these Excel columns:

```
#ACA17234=5;1'Some Message'
#ACA17232<5;1'Some Message'
#ACA17238_2_5;1'Some Message'
#ACA17239_2_5;1'Some Message'
#ACA17237_2_5;1'Some Message'

```

I want to a Excel function that takes exactly five numbers which gave me ;
17234,17232,17238,17239,17237

Edit:

```
((#ACA18655=0)&(#AGV32=6)&(#ACA18702=1))?((#FC1000ACA18701$3)?'Eksper ücretini onaylayınız..':''):((#ACA18540>0)?((#ACA18540$#ACA18541)?'Otoanalizden aktarılan ve dosya üzerinde atalı olan AT kodu farklı !!':''):'')

```

Not all rows are started with `#ACA` I have rows like these

Answer: 
This is how I would do it - [CodePen](http://codepen.io/camden-kid/pen/mEzJKG?editors=1010#0)

This solution is flexible to allow for changes to user information.

Markup

```
<div ng-controller="AppCtrl" ng-cloak="" ng-app="MyApp" layout-fill>
  <div ng-if="showRow">
    <div ng-repeat="user in users">
      <div ng-if="$first">
        <div layout="row">
          <span flex ng-repeat="(key, value) in users[0]">
            {{key}}
          </span>
        </div>
        <md-divider></md-divider>
      </div>
      <div layout="row">
        <span flex ng-repeat="(key, value) in user">
          {{value}}
        </span>
      </div>
    </div>
  </div>

  <div display="column" ng-if="showColumn">
    <div ng-repeat="user in users">
      <div ng-repeat="(key, value) in user" layout="row">
        <span flex>{{key}}</span>
        <span flex>{{value}}</span>
      </div>
      <md-divider></md-divider>
    </div>
  </div>
</div>

```

JS

```
angular.module('MyApp',['ngMaterial', 'ngMessages'])

.controller('AppCtrl', function($scope, $mdMedia, $window) {
  $scope.users = [
    {Name: "Alice", City: "NY", Gender: "f"},
    {Name: "Bob", City: "LA", Gender: "m"}
  ];
  $scope.showColumn = false;
  $scope.showRow = true;

  display();

  angular.element($window).bind("resize", function() {
    display();
    $scope.$apply();
  });

  function display () {
     if ($mdMedia("gt-xs")) {
        $scope.showColumn = false;
        $scope.showRow = true;
      }
      else if ($mdMedia("xs")) {
        $scope.showColumn = true;
        $scope.showRow = false;
      }
  }
});

```
I'm not sure you can do it using a table, but the material library offers very powerful features with flexbox that does allow for the responsive layout that you are describing. Seemed like an interesting problem so I had a go at doing a plunkr.

The html below will adjust the layout and display / hide various labels to achieve the result you want. Try changing the size of your browser when viewing the plunkr, there is a breakpoint that will switch the views.

```
<div layout="row" flex hide show-gt-md>
  <div flex="20">Name</div>
  <div flex="20">City</div>
  <div flex="20">Gender</div>
</div>
<div ng-repeat="p in data" layout-gt-md="row" layout="column">
  <div flex="20" layout="row">
    <div flex="30" hide-gt-md>Name</div>
    {{p.name}}
  </div>
  <div flex="20" layout="row">
    <div flex="30" hide-gt-md>City</div>
    {{p.city}}
  </div>
  <div flex="20" layout="row">
    <div flex="30" hide-gt-md>Gender</div>
    {{p.gender}}
    </div>
</div>

```

<https://plnkr.co/rvgwYMjlFazvM4SXyOtC>